﻿CREATE TABLE [dbo].[tblAccountActivityDetail] (
    [AccountActivityID] INT           NOT NULL,
    [ChangedFrom]       VARCHAR (255) NULL,
    [ChangedTo]         VARCHAR (255) NULL
);
GO
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Records the changes made to a customer account.  Links to tblAccountActivity on AccountActivityID.
 There can be multiple activity records for a single customer number.', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblAccountActivityDetail';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'The account activity ID.  Links to tblAccountActivity.', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblAccountActivityDetail',
	@level2type = N'COLUMN', @level2name = N'AccountActivityID';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Records the entry that is being replaced.', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblAccountActivityDetail',
	@level2type = N'COLUMN', @level2name = N'ChangedFrom';
GO;
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Records the new entry for the field that is being changed.', 
	@level0type = N'SCHEMA', @level0name = N'dbo',
	@level1type = N'TABLE', @level1name = N'tblAccountActivityDetail',
	@level2type = N'COLUMN', @level2name = N'ChangedTo';

